<!-- <!DOCTYPE html>
<html lang="zh-cn" ng-app="app" ng-controller="hxzgqcController">
<title>清册</title>
<meta charset="UTF-8">
#include("/WEB-INF/pages/tpl/header.vm")
#include("/WEB-INF/pages/tpl/navbar.vm")
<script src="../js/gt3/hxzgqc.js"></script>
<script src="../js/ext/queue.js"></script>
</head>
<body>
	<div class="container">
	<h3>{{msg}}</h3>
	<button type="button" class="btn btn-warning" ng-click="impExl =! impExl" ng-show="isAdmin == true">导入</button>
	<button type="button" class="btn btn-success" ng-click="getTable('ywbmc')">查询业务表清册</button>
	<button type="button" class="btn btn-success" ng-click="getTable('dmbmc')">查询代码参数权限表名称清册</button>
	<br>
	<div class="row">
		<div class="col-lg-6">
	    	<div class="input-group">
	      		<input type="text" class="form-control" placeholder="模糊查询" ng-model="advance_search">
	      		<span class="input-group-btn"><button class="btn btn-info" type="button" ng-click="goAdSearch()">模糊搜索</button></span>
	    	</div>
	  	</div>
	</div>
	
	<div class="row">
		<div class="col-lg-6">
	    	<div class="input-group">
	      		<input type="text" class="form-control" placeholder="查询表英文名称" ng-model="exact.value">
	      		<span class="input-group-btn"><button class="btn btn-info" type="button" ng-click="exactSearch()">精确查找</button></span>
	      		<input type="radio" name="exactType" value="bmc" ng-model="exact.type"> 表名称
	      		<input type="radio" name="exactType" value="bzd" ng-model="exact.type"> 表字段
	    	</div>
	  	</div>
	</div>
	
	<div ng-show="showType == 'exactbzd'">
		<table class="table table-hover">
			<tr>
				<th>序号</th>
				<th>表中文名称</th>
				<th>表英文名称</th>
				<th>字段中文名称</th>
				<th>字段英文名称</th>
			</tr>
			<tr ng-repeat="tb in exact.bzdrec">
				<td>{{$index + 1}}</td>
				<td><a href="javascript:;" ng-click="getField(this)">{{tb.NAME_EN}}</a></td>	
				<td>{{tb.NAME_ZH}}</td>	
				<td>{{tb.FIELD_EN}}</td>
				<td>{{tb.FIELD_ZH}}</td>	
			</tr>
		</table>
		<button class="btn btn-info" type="button" ng-click="showType = lastShowType">返回</button>
	</div>
	
	<div ng-show="showType == 'exactbmc'">
		<table class="table table-hover">
			<tr>
				<th>序号</th>
				<th>OWNER</th>
				<th>用户</th>
				<th>物理表名称</th>
				<th>物理表中文名称</th>
				<th>包含字段总数</th>
			</tr>
			<tr ng-repeat="tb in exact.bmcrec">
				<td>{{$index + 1}}</td>	
				<td>{{tb.OWNER}}</td>	
				<td>{{tb.USER}}</td>	
				<td>{{tb.NAME_EN}}</td>
				<td>{{tb.NAME_ZH}}</td>	
				<td><a href="javascript:;" ng-click="getField(this)">{{tb.FIELDS}}</a></td>	
			</tr>
		</table>
		<button class="btn btn-info" type="button" ng-click="showType = lastShowType">返回</button>
	</div>
	
	<div ng-show="showType == 'dmbmc'">
		<table class="table table-hover">
			<tr>
				<th>序号</th>
				<th>OWNER</th>
				<th>用户</th>
				<th>物理表名称</th>
				<th>物理表中文名称</th>
				<th>包含字段总数</th>
			</tr>
			<tr ng-repeat="tb in dmbmcTable.list">
				<td>{{$index + 1 + (dmbmcTable.pageNumber-1) * dmbmcTable.pageSize}}</td>	
				<td>{{tb.OWNER}}</td>	
				<td>{{tb.USER}}</td>	
				<td ng-show="tb.EXT == 1"><a href="javascript:;" ng-click="getDDL(this)">{{tb.NAME_EN}}</a></td>	
				<td ng-show="tb.EXT != 1">{{tb.NAME_EN}}</td>
				<td>{{tb.NAME_ZH}}</td>	
				<td><a href="javascript:;" ng-click="getField(this)">{{tb.FIELDS}}</a></td>	
			</tr>
		</table>
		<a href="javascript:;" ng-click="pageChange('dmbmc', 'pre')" ng-show="dmbmcTable.firstPage!=true">上一页</a>
		第{{dmbmcTable.pageNumber}}页<br/>
		每页<input type="number" ng-model="dmbmcTable.pageSize">条
		共{{dmbmcTable.totalPage}}页<br/>
		共{{dmbmcTable.totalRow}}条<br/>
		是否首页：{{dmbmcTable.firstPage}}<br/>
		是否末页：{{dmbmcTable.lastPage}}<br/>
		<a href="javascript:;" ng-click="pageChange('dmbmc', 'next')" ng-show="dmbmcTable.lastPage!=true">下一页</a>
	</div>
	
	<div ng-show="showType == 'ywbmc'">
		<table class="table table-hover">
			<tr>
				<th>序号</th>
				<th>OWNER</th>
				<th>用户</th>
				<th>物理表名称</th>
				<th>物理表中文名称</th>
				<th>包含字段总数</th>
				<th>备注</th>
			</tr>
			<tr ng-repeat="tb in ywbmcTable.list">
				<td>{{$index + 1 + (ywbmcTable.pageNumber-1) * ywbmcTable.pageSize}}</td>
				<td>{{tb.OWNER}}</td>	
				<td>{{tb.USER}}</td>	
				<td ng-show="tb.EXT == 1"><a href="javascript:;" ng-click="getDDL(this)">{{tb.NAME_EN}}</a></td>	
				<td ng-show="tb.EXT != 1">{{tb.NAME_EN}}</td>	
				<td>{{tb.NAME_ZH}}</td>	
				<td><a href="javascript:;" ng-click="getField(this)">{{tb.FIELDS}}</a></td>	
				<td>{{tb.BZ}}</td>	
			</tr>
		</table>
		<a href="javascript:;" ng-click="pageChange('ywbmc', 'pre')" ng-show="ywbmcTable.firstPage!=true">上一页</a>
		第{{ywbmcTable.pageNumber}}页<br/>
		每页<input type="number" ng-model="ywbmcTable.pageSize">条<br/>
		共{{ywbmcTable.totalPage}}页<br/>
		共{{ywbmcTable.totalRow}}条<br/>
		是否首页：{{ywbmcTable.firstPage}}<br/>
		是否末页：{{ywbmcTable.lastPage}}<br/>
		<a href="javascript:;" ng-click="pageChange('ywbmc', 'next')" ng-show="ywbmcTable.lastPage!=true">下一页</a>
	</div>
	<div ng-show="showType == 'fields'">
		<table class="table table-hover table-bordered">
			<tr>
				<th>序号</th>
				<th>字段名称</th>
				<th>字段中文名称</th>
				<th>数据类型</th>
				<th>字段属性</th>
				<th>是否主键标志</th>
				<th>可空标志</th>
			</tr>
			<tr ng-repeat="tb in fields">
				<td>{{$index + 1}}</td>
				<td>{{tb.FIELD_EN}}</td>	
				<td>{{tb.FIELD_ZH}}</td>	
				<td>{{tb.FIELD_TYPE}}</td>	
				<td>{{tb.PROPERTY}}</td>	
				<td>{{tb.IS_PRIMARY}}</td>	
				<td>{{tb.IS_NULL}}</td>	
			</tr>
		</table>
		<button class="btn btn-info" type="button" ng-click="showType = lastShowType">返回</button>
	</div>
	<div ng-show="showType == 'ddls'">
		DDL:
		<div>
			{{ddls}}
		</div>
	</div>

	<div ng-show="impExl == true">
		<table>
			<tr>
				<td>
					<form method="post" enctype="multipart/form-data" id="submitForm"
						action="./postExcel">
						<table>
							<tr>
								<td>类型：</td>
								<td><select ng-model="uploadType" name="type"
									ng-options="t.v as t.k for t in types"></select></td>
							</tr>
							<tr>
								<td>Excel：</td>
								<td><input type="file" name="file" id="uploadFile"></input></td>
							</tr>
						</table>
					</form>
				</td>
			</tr>
			<tr>
				<td>
					<button ng-click="importExcel()" class="btn btn-danger" type="button" >导入</button>
					<button ng-click="impExl =! impExl">取消</button>
				</td>
			</tr>
		</table>
		<div>
			<button ng-click="batchDDL()">扫描DDL</button>
		</div>
	</div>
	</div>
</body>
</html> -->